Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	5695
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	534.0 KiB
Average record size in memory	96.0 B

Variable types

Numeric	12

Alerts

`gross_revenue` is highly correlated with `qty_invoice_no` and 3 other fields	High correlation
`recency_days` is highly correlated with `qty_invoice_no`	High correlation
`qty_invoice_no` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`qty_items` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`qty_products` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`frequency` is highly correlated with `qty_invoice_no` and 1 other fields	High correlation
`qty_returns` is highly correlated with `qty_invoice_no`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `qty_products` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qty_invoice_no` and 1 other fields	High correlation
`qty_invoice_no` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qty_items` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`qty_products` is highly correlated with `qty_invoice_no`	High correlation
`avg_ticket` is highly correlated with `qty_returns` and 1 other fields	High correlation
`qty_returns` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`df_index` is highly correlated with `qty_invoice_no` and 1 other fields	High correlation
`customer_id` is highly correlated with `qty_invoice_no` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qty_items` and 3 other fields	High correlation
`recency_days` is highly correlated with `qty_invoice_no` and 1 other fields	High correlation
`qty_invoice_no` is highly correlated with `df_index` and 3 other fields	High correlation
`qty_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qty_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`frequency` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qty_returns` is highly correlated with `df_index` and 3 other fields	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `qty_products`	High correlation
`df_index` is highly correlated with `customer_id` and 1 other fields	High correlation
`customer_id` is highly correlated with `df_index` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qty_invoice_no` and 2 other fields	High correlation
`recency_days` is highly correlated with `df_index` and 1 other fields	High correlation
`qty_invoice_no` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qty_items` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`qty_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_ticket` is highly correlated with `qty_items` and 2 other fields	High correlation
`qty_returns` is highly correlated with `qty_items` and 2 other fields	High correlation
`avg_basket_size` is highly correlated with `qty_items` and 2 other fields	High correlation
`gross_revenue` is highly skewed (γ1 = 22.58539738)	Skewed
`qty_items` is highly skewed (γ1 = 24.06874032)	Skewed
`avg_ticket` is highly skewed (γ1 = 71.30308417)	Skewed
`qty_returns` is highly skewed (γ1 = 71.05769911)	Skewed
`avg_basket_size` is highly skewed (γ1 = 58.3280441)	Skewed
`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`qty_returns` has 4191 (73.6%) zeros	Zeros

Reproduction

Analysis started	2022-03-12 18:17:23.943312
Analysis finished	2022-03-12 18:17:39.839252
Duration	15.9 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	5695
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2895.799122

Minimum	0
Maximum	5785
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0
5-th percentile	289.7
Q1	1454.5
median	2898
Q3	4340.5
95-th percentile	5494.3
Maximum	5785
Range	5785
Interquartile range (IQR)	2886

Descriptive statistics

Standard deviation	1668.934084
Coefficient of variation (CV)	0.57632937
Kurtosis	-1.196239242
Mean	2895.799122
Median Absolute Deviation (MAD)	1443
Skewness	-0.003571604469
Sum	16491576
Variance	2785340.976
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3889	1	< 0.1%
3865	1	< 0.1%
3864	1	< 0.1%
3863	1	< 0.1%
3862	1	< 0.1%
3861	1	< 0.1%
3860	1	< 0.1%
3859	1	< 0.1%
3858	1	< 0.1%
Other values (5685)	5685	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5785	1	< 0.1%
5784	1	< 0.1%
5783	1	< 0.1%
5782	1	< 0.1%
5781	1	< 0.1%
5780	1	< 0.1%
5779	1	< 0.1%
5778	1	< 0.1%
5777	1	< 0.1%
5776	1	< 0.1%

customer_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	5695
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16600.59895

Minimum	12346
Maximum	22709
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	12346
5-th percentile	12699.1
Q1	14288.5
median	16227
Q3	18210.5
95-th percentile	21731.1
Maximum	22709
Range	10363
Interquartile range (IQR)	3922

Descriptive statistics

Standard deviation	2808.241892
Coefficient of variation (CV)	0.1691650946
Kurtosis	-0.8211159178
Mean	16600.59895
Median Absolute Deviation (MAD)	1963
Skewness	0.4412705454
Sum	94540411
Variance	7886222.521
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
21110	1	< 0.1%
13745	1	< 0.1%
15584	1	< 0.1%
21089	1	< 0.1%
21088	1	< 0.1%
21087	1	< 0.1%
21086	1	< 0.1%
15578	1	< 0.1%
12424	1	< 0.1%
Other values (5685)	5685	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12346	1	< 0.1%
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%

Value	Count	Frequency (%)
22709	1	< 0.1%
22708	1	< 0.1%
22707	1	< 0.1%
22706	1	< 0.1%
22705	1	< 0.1%
22704	1	< 0.1%
22700	1	< 0.1%
22699	1	< 0.1%
22696	1	< 0.1%
22695	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	5449
Distinct (%)	95.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1774.303486

Minimum	0.42
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0.42
5-th percentile	13.171
Q1	236.135
median	613.2
Q3	1570.74
95-th percentile	5309.696
Maximum	279138.02
Range	279137.6
Interquartile range (IQR)	1334.605

Descriptive statistics

Standard deviation	7582.209661
Coefficient of variation (CV)	4.273344286
Kurtosis	675.6156928
Mean	1774.303486
Median Absolute Deviation (MAD)	479.19
Skewness	22.58539738
Sum	10104658.35
Variance	57489903.34
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.95	9	0.2%
2.95	8	0.1%
4.95	8	0.1%
1.25	8	0.1%
3.75	7	0.1%
12.75	7	0.1%
1.65	7	0.1%
5.95	6	0.1%
7.5	6	0.1%
4.25	6	0.1%
Other values (5439)	5623	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.42	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.84	4	0.1%
0.85	3	0.1%
1.07	1	< 0.1%
1.25	8	0.1%
1.44	1	< 0.1%
1.65	7	0.1%
1.69	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
77183.6	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	304
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.9276558

Minimum	0
Maximum	373
Zeros	37
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	23
median	71
Q3	200
95-th percentile	338
Maximum	373
Range	373
Interquartile range (IQR)	177

Descriptive statistics

Standard deviation	111.6463634
Coefficient of variation (CV)	0.9548328206
Kurtosis	-0.6426259548
Mean	116.9276558
Median Absolute Deviation (MAD)	61
Skewness	0.8143144842
Sum	665903
Variance	12464.91047
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	110	1.9%
4	105	1.8%
3	98	1.7%
2	92	1.6%
10	86	1.5%
8	82	1.4%
17	79	1.4%
9	79	1.4%
7	78	1.4%
15	66	1.2%
Other values (294)	4820	84.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	37	0.6%
1	110	1.9%
2	92	1.6%
3	98	1.7%
4	105	1.8%
5	52	0.9%
7	78	1.4%
8	82	1.4%
9	79	1.4%
10	86	1.5%

Value	Count	Frequency (%)
373	23	0.4%
372	23	0.4%
371	17	0.3%
369	4	0.1%
368	13	0.2%
367	16	0.3%
366	15	0.3%
365	19	0.3%
364	11	0.2%
362	7	0.1%

qty_invoice_no
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	56
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.471290606

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	4
95-th percentile	11
Maximum	206
Range	205
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	6.813294304
Coefficient of variation (CV)	1.962755378
Kurtosis	302.0907206
Mean	3.471290606
Median Absolute Deviation (MAD)	0
Skewness	13.19278315
Sum	19769
Variance	46.42097928
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2871	50.4%
2	825	14.5%
3	503	8.8%
4	394	6.9%
5	237	4.2%
6	173	3.0%
7	138	2.4%
8	98	1.7%
9	69	1.2%
10	55	1.0%
Other values (46)	332	5.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2871	50.4%
2	825	14.5%
3	503	8.8%
4	394	6.9%
5	237	4.2%
6	173	3.0%
7	138	2.4%
8	98	1.7%
9	69	1.2%
10	55	1.0%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	< 0.1%
60	1	< 0.1%
57	1	< 0.1%

qty_items
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1840
Distinct (%)	32.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	964.4258121

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	106
median	317
Q3	804.5
95-th percentile	2931.8
Maximum	196844
Range	196843
Interquartile range (IQR)	698.5

Descriptive statistics

Standard deviation	4300.208161
Coefficient of variation (CV)	4.458827322
Kurtosis	863.3991637
Mean	964.4258121
Median Absolute Deviation (MAD)	253
Skewness	24.06874032
Sum	5492405
Variance	18491790.23
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	114	2.0%
2	73	1.3%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
12	25	0.4%
88	22	0.4%
72	21	0.4%
7	20	0.4%
Other values (1830)	5256	92.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	114	2.0%
2	73	1.3%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
7	20	0.4%
8	18	0.3%
9	7	0.1%
10	17	0.3%

Value	Count	Frequency (%)
196844	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
74215	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%

qty_products
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	529
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92.609482

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	14
median	41
Q3	106
95-th percentile	332.3
Maximum	7838
Range	7837
Interquartile range (IQR)	92

Descriptive statistics

Standard deviation	210.5785979
Coefficient of variation (CV)	2.273834097
Kurtosis	510.2942936
Mean	92.609482
Median Absolute Deviation (MAD)	33
Skewness	17.75339398
Sum	527411
Variance	44343.34589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	256	4.5%
2	149	2.6%
3	108	1.9%
10	101	1.8%
6	99	1.7%
9	92	1.6%
5	91	1.6%
4	87	1.5%
11	83	1.5%
7	83	1.5%
Other values (519)	4546	79.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	256	4.5%
2	149	2.6%
3	108	1.9%
4	87	1.5%
5	91	1.6%
6	99	1.7%
7	83	1.5%
8	81	1.4%
9	92	1.6%
10	101	1.8%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1226
Distinct (%)	21.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5472966614

Minimum	0.005449591281
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.01104363016
Q1	0.02492643315
median	1
Q3	1
95-th percentile	1
Maximum	17
Range	16.99455041
Interquartile range (IQR)	0.9750735668

Descriptive statistics

Standard deviation	0.5502573935
Coefficient of variation (CV)	1.005409739
Kurtosis	139.1369501
Mean	0.5472966614
Median Absolute Deviation (MAD)	0
Skewness	4.858644853
Sum	3116.854487
Variance	0.3027831991
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2879	50.6%
2	47	0.8%
0.0625	18	0.3%
0.02777777778	17	0.3%
0.02380952381	16	0.3%
0.08333333333	15	0.3%
0.09090909091	15	0.3%
0.03448275862	14	0.2%
0.02941176471	14	0.2%
0.03571428571	13	0.2%
Other values (1216)	2647	46.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	< 0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	< 0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	< 0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
4	1	< 0.1%
3	5	0.1%
2	47	0.8%
1.142857143	1	< 0.1%
1	2879	50.6%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	5502
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.74707736

Minimum	0.42
Maximum	77183.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0.42
5-th percentile	3.460023492
Q1	7.95
median	15.85416667
Q3	21.98419438
95-th percentile	76.32
Maximum	77183.6
Range	77183.18
Interquartile range (IQR)	14.03419438

Descriptive statistics

Standard deviation	1043.79839
Coefficient of variation (CV)	23.32662716
Kurtosis	5245.740162
Mean	44.74707736
Median Absolute Deviation (MAD)	7.495745614
Skewness	71.30308417
Sum	254834.6056
Variance	1089515.079
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.75	11	0.2%
4.95	10	0.2%
2.95	9	0.2%
1.25	9	0.2%
7.95	8	0.1%
12.75	7	0.1%
1.65	7	0.1%
8.25	7	0.1%
3.35	6	0.1%
15	6	0.1%
Other values (5492)	5615	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.42	3	0.1%
0.535	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.8371428571	1	< 0.1%
0.84	2	< 0.1%
0.85	3	0.1%
1.002222222	1	< 0.1%
1.02	1	< 0.1%
1.03875	1	< 0.1%

Value	Count	Frequency (%)
77183.6	1	< 0.1%
13305.5	1	< 0.1%
4453.43	1	< 0.1%
3861	1	< 0.1%
3202.92	1	< 0.1%
3096	1	< 0.1%
1687.2	1	< 0.1%
1377.077778	1	< 0.1%
1001.2	1	< 0.1%
952.9875	1	< 0.1%

qty_returns
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	214
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.26830553

Minimum	0
Maximum	74215
Zeros	4191
Zeros (%)	73.6%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	38.3
Maximum	74215
Range	74215
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1004.321707
Coefficient of variation (CV)	32.11947976
Kurtosis	5232.359476
Mean	31.26830553
Median Absolute Deviation (MAD)	0
Skewness	71.05769911
Sum	178073
Variance	1008662.091
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4191	73.6%
1	169	3.0%
2	150	2.6%
3	105	1.8%
4	89	1.6%
6	78	1.4%
5	61	1.1%
12	52	0.9%
7	44	0.8%
8	43	0.8%
Other values (204)	713	12.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4191	73.6%
1	169	3.0%
2	150	2.6%
3	105	1.8%
4	89	1.6%
5	61	1.1%
6	78	1.4%
7	44	0.8%
8	43	0.8%
9	41	0.7%

Value	Count	Frequency (%)
74215	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	2369
Distinct (%)	41.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	261.1135614

Minimum	1
Maximum	74215
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	75
median	151.6666667
Q3	290.3125
95-th percentile	733.5625
Maximum	74215
Range	74214
Interquartile range (IQR)	215.3125

Descriptive statistics

Standard deviation	1074.145537
Coefficient of variation (CV)	4.113710262
Kurtosis	3957.958196
Mean	261.1135614
Median Absolute Deviation (MAD)	96.66666667
Skewness	58.3280441
Sum	1487041.732
Variance	1153788.635
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	115	2.0%
2	72	1.3%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
12	26	0.5%
100	22	0.4%
72	22	0.4%
73	21	0.4%
Other values (2359)	5253	92.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	115	2.0%
2	72	1.3%
3	51	0.9%
3.333333333	1	< 0.1%
4	49	0.9%
5	35	0.6%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6	29	0.5%
6.142857143	1	< 0.1%

Value	Count	Frequency (%)
74215	1	< 0.1%
14149	1	< 0.1%
13956	1	< 0.1%
7824	1	< 0.1%
6009.333333	1	< 0.1%
5963	1	< 0.1%
5197	1	< 0.1%
4300	1	< 0.1%
4282	1	< 0.1%
4280	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1171
Distinct (%)	20.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.2557656

Minimum	0.2
Maximum	1109
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0.2
5-th percentile	1
Q1	7.25
median	15
Q3	31
95-th percentile	173
Maximum	1109
Range	1108.8
Interquartile range (IQR)	23.75

Descriptive statistics

Standard deviation	76.88286317
Coefficient of variation (CV)	2.063650067
Kurtosis	32.88891715
Mean	37.2557656
Median Absolute Deviation (MAD)	10
Skewness	5.07356894
Sum	212171.5851
Variance	5910.97465
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	278	4.9%
2	161	2.8%
3	115	2.0%
10	105	1.8%
9	105	1.8%
8	103	1.8%
5	101	1.8%
7	101	1.8%
6	101	1.8%
13	97	1.7%
Other values (1161)	4428	77.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	7	0.1%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.2%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
1109	1	< 0.1%
748	1	< 0.1%
730	1	< 0.1%
720	1	< 0.1%
703	1	< 0.1%
686	1	< 0.1%
675	1	< 0.1%
673	1	< 0.1%
660	1	< 0.1%
649	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qty_invoice_no	qty_items	qty_products	frequency	avg_ticket	qty_returns	avg_basket_size	avg_unique_basket_size
0	0	17850	5391.21	372.0	34.0	1733.0	297.0	17.000000	18.152222	40.0	50.970588	0.617647
1	1	13047	3232.59	56.0	9.0	1390.0	171.0	0.028302	18.904035	35.0	154.444444	11.666667
2	2	12583	6705.38	2.0	15.0	5028.0	232.0	0.040323	28.902500	50.0	335.200000	7.600000
3	3	13748	948.25	95.0	5.0	439.0	28.0	0.017921	33.866071	0.0	87.800000	4.800000
4	4	15100	876.00	333.0	3.0	80.0	3.0	0.073171	292.000000	22.0	26.666667	0.333333
5	5	15291	4623.30	25.0	14.0	2102.0	102.0	0.040115	45.326471	29.0	150.142857	4.357143
6	6	14688	5630.87	7.0	21.0	3621.0	327.0	0.057221	17.219786	399.0	172.428571	7.047619
7	7	17809	5411.91	16.0	12.0	2057.0	61.0	0.033520	88.719836	41.0	171.416667	3.833333
8	8	15311	60767.90	0.0	91.0	38194.0	2379.0	0.243316	25.543464	474.0	419.714286	6.230769
9	9	16098	2005.63	87.0	7.0	613.0	67.0	0.024390	29.934776	0.0	87.571429	4.857143

Last rows

	df_index	customer_id	gross_revenue	recency_days	qty_invoice_no	qty_items	qty_products	frequency	avg_ticket	avg_basket_size	avg_unique_basket_size
5685	5776	22700	4839.42	1.0	1.0	1074.0	62.0	1.0	78.055161	1074.0	55.0
5686	5777	13298	360.00	1.0	1.0	96.0	2.0	1.0	180.000000	96.0	2.0
5687	5778	14569	227.39	1.0	1.0	79.0	12.0	1.0	18.949167	79.0	10.0
5688	5779	22704	17.90	1.0	1.0	14.0	7.0	1.0	2.557143	14.0	7.0
5689	5780	22705	3.35	1.0	1.0	2.0	2.0	1.0	1.675000	2.0	2.0
5690	5781	22706	5699.00	1.0	1.0	1747.0	634.0	1.0	8.988959	1747.0	634.0
5691	5782	22707	6756.06	0.0	1.0	2010.0	730.0	1.0	9.254877	2010.0	730.0
5692	5783	22708	3217.20	0.0	1.0	654.0	59.0	1.0	54.528814	654.0	56.0
5693	5784	22709	3950.72	0.0	1.0	731.0	217.0	1.0	18.206083	731.0	217.0
5694	5785	12713	794.55	0.0	1.0	505.0	37.0	1.0	21.474324	505.0	37.0

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows